CREATE PROCEDURE spUpdatePerson
	@PersonID INT,
	@FirstName NVARCHAR(50),
	@LastName NVARCHAR(50),
	@Phone VARCHAR(10),
	@Email NVARCHAR(50),
	@Birthday DATETIME,
	@Photo VARCHAR(260),
	@GroupID INT
AS
BEGIN
	   UPDATE
	      tblPersons
	   SET
		   FirstName = @FirstName,
		   LastName = @LastName,
		   Phone = @Phone,
		   Email = @Email,
		   Birthday = @Birthday,
		   Photo = @Photo,
		   GroupID=@GroupID
	   WHERE
	      PersonID=@PersonID
END
GO
